
<%@page import="java.sql.Connection" %>
<%@page import="java.sql.PreparedStatement" %>
<%@page import="java.sql.ResultSet" %>
<%@page import="java.sql.SQLException" %>
<%@page import="javax.sql.DataSource" %>
<%@page import="javax.naming.InitialContext" %>
<%@page import="javax.naming.NamingException" %>

<%
	DataSource DS;
	InitialContext cxt;
	DataSource ds = null;
	try {
		cxt = new InitialContext();
		ds = (DataSource) cxt.lookup("java:/comp/env/jdbc/HealthService");
	} catch (NamingException e) {
		ds = null;
		throw new IllegalStateException(
				"Impossibile recuperare il pool di connessioni al database: "
						+ e.getMessage());
	} finally {
		DS = ds;
	}
	String statement;//="Select nome from Categoria";
	Connection con;//=DS.getConnection();
	PreparedStatement pstmt;// = con.prepareStatement(statement);
	ResultSet rs;// =pstmt.executeQuery();
%>

<table  border="0" cellspacing="0" cellpadding="0">
      <tr align="left" valign="top">
        <td>
        <table width="192" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td height="38" class="topMenu LeftMenuHeader" >Azioni</td>
          </tr>
        </table>          
          <table   border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td  valign="top">
                <div class="RightMenu">
                  <ul>
                  	<li><a href="create_ordine_fornitore.jsp" id="WhiteColor2">Nuovo Ordine Fornitore</a></li>
                  	<li><a href="ordina_materia_prima.jsp" id="WhiteColor2">Nuovo Ordine MP</a></li>
                  	<li><a href="create_produce.jsp" id="WhiteColor2">Nuova Produzione</a></li>
                  	<li><a href="create_fornitore.jsp" id="WhiteColor2">Nuovo Fornitore</a></li>
                  	<li><a href="assegna_fornitori_pag.jsp" id="WhiteColor2">Assegna Fornitori</a></li>
                  	
                
                  	<li><a href="view_ordini_fabbriche.jsp" id="WhiteColor2">Ordini Fabbriche</a></li>
					<li><a href="view_ordini_fornitura.jsp" id="WhiteColor2">Ordini Fornitori</a></li>
					<li><a href="view_ordini_materia.jsp" id="WhiteColor2">Ordini Materie Prime</a></li>
				
					<li><a href="view_fabbriche.jsp" id="WhiteColor2">Elenco Fabbriche</a></li>
					<li><a href="view_fornitori.jsp" id="WhiteColor2">Elenco Fornitori</a></li>
					<li><a href="view_materia_prima.jsp" id="WhiteColor2">Elenco Materie Prime</a></li>
                  </ul>
              </div></td>
            </tr>
          </table>
          </td>
      </tr>
</table>